package com.itheima.mapper;

import com.itheima.pojo.Dept;
import org.apache.ibatis.annotations.*;

import java.util.List;
public interface DeptMapper {
    @Select("select * from dept")
     public List<Dept> findAll() ;


    @Delete("delete  from dept where id = #{id}")
    void deleteById(Integer id);


    //新增部门
    @Insert("insert into dept ( name, create_time, update_time) values (#{name},#{createTime},#{updateTime})")
    void addDepartment(Dept dept);


    //根据id查询
    @Select("select  *  from dept  where id =#{id}")
    public Dept queryById(Integer id);


    //修改部门
    @Update("update dept set name =#{name},update_time =#{updateTime} where id = #{id}")
    void modifyDepartment(Dept dept);
}
